
CREATE TABLE EitEvents
(
	Id int identity,
	NetworkId int,
	TransportId int,
	ServiceId int,
	EventId int,
	StartTime datetime,
	EndTime datetime,
	Duration int,
	[Language] char(3),
	EventName nvarchar(255),
	[Text] nvarchar(255)
)
GO

CREATE UNIQUE INDEX PK_EitEvents ON EitEvents
(NetworkId, TransportId, ServiceId, EventId, [Language])
GO

CREATE CLUSTERED INDEX IX_EitEvents_NTSLSE ON EitEvents
(NetworkId, TransportId, ServiceId, [Language], StartTime)
GO

